iLoADER |
HOME |
Expression based dynamic fields exampleAn Expression based dynamic field allows you to combine and manipulate data (usually from separate fields) using standard operators. An Expression script is written in the following format: EXPRESSION, Full Table Name, Dynamic Field Name, {Expression} If you are using the Data Transformation wizard, these entries relate to the column fields as follows:
The following example creates an Expression based dynamic field that generates a salutation by combining the [Title] and [Surname] fields. EXPRESSION, [Demo].[Customer], Salutation, {“Dear “ [Demo].[Customer].[Title] + “ “ + [Demo].[Customer].[Surname]} |
Online & Instructor-Led Courses | Training Videos | Webinar Recordings | ![]() |
|
![]() |
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice | ![]() ![]() ![]() |